Installing Oracle 9i on Windows XP

The following outline describes the steps required to install Oracle9i Release 2 (9.2.0.1.0) on the Microsoft Windows XP operating system. It is assumed that this is a fresh install and that no other Oracle products are installed at this time. If this is not the case, then these instructions may not work on your system.

Checklist

Before you even start this process you should have:

  • A Pentium III or Pentium 4 based PC with at least 800 MHz processor, 256 MB of RAM (512 is much better) and at least 10 Gigabytes of free disk space.
  • If you only have 256 MB of RAM, make sure you have Windows manage at least 400 MB swap file (virtual memory).
  • This machine MUST be running Windows 2000 with service pack 1 or (preferably) 2 installed or windows XP (Windows NT in general) If you are running MS IIS, disable the web server (running on Port 80 by default) before starting the Oracle 9i installation.
  • At least 10 GB of free disk space: 
·                  Space to source ZIP files:  1.30 GB
·                  Space to unpack source ZIP files: 1.40 GB
·                  Space to install Oralce9i Software: 2.0 to 3.04 GB
 

The Installation Process

As with most Windows installation programs, inserting the CD-ROM into the CD-ROM drive automatically executes the setup program. (If this does not happen, use the Windows Explorer to view the contents of your CD-ROM drive and double click on the "setup" program there).

If you downloaded the Oracle9i from Oracle Technet, then you need to unzip the files into a three temporary directories and double click on the setup.exe program in the Disk1 directory) to get the installation process started.

The following Welcome window will appear: 

 
 

It is assumed that this is a fresh install so no other Oracle products should be installed at this time.

Click on the Next button to move to the File Locations screen as shown below: 

 

In this screen, the Source and Destination locations must be selected.

The Source path should reflect either your CD-ROM or the directory in which you unzipped the source files. Leave this as the default. In the example above, the source files were unzipped into E:\DISKS\Oracle.ZIP\Disk1 directory.

For the Destination, leave the Oracle Home named OraHome90 as the default. Choose a hard disk drive that has at least 10 gigabytes of free space. In the example here, we are using the E: drive.

Leave the \Oracle\Ora92 path as it is (the default). If you must change this to a different drive, only change the drive letter and not the directories.

Click on the Next button to load the Product information. This may take up to 2 minutes (depending on the speed of your machine). Once the product information has been read, the following 3 "Available Products" options are presented: 

 

Make sure the Oracle9i Database 9.2.0.1.0 is selected and click on the Next button.

The "Installation Types" screen will appear next. For this installation, we chose the Enterprise Edition. 

 

The "Database Configuration" screen will appear next: 

 

For this install, we chose the "General Purpose" Database option. Click on the Next button to continue.

The next step is to identify the database using the Global database name: 

 

If some default Global database name and SID are given, keep them. Otherwise, use the following (make a note of these for later on):
Global Database Name is orcl
Oracle SID is orcl

Click on the Next button to continue to the "Data File Location” screen 

 

In this step, you need to select where the Oracle data files will be located. In large operations, we typically keep the data files on a separate disk (or disks), however, for this install, we are storing the data files in the same D:\oracle directory tree. Keep the default as shown and click on the Next button to continue.

In the next screen, choose the default character set for the database: 

 
Click on the Next button to move to the "Summary" screen: 
 

In this screen (shown above), the products and files that will be installed are summarized. Note that in this example, it will take 1.5 GB MB of disk space for the installation of the software. Additional space will be required for the default database.

If everything looks OK at this point, click on the Install button to begin the installation.

During the install, you will notice various Oracle products being copied over to the hard disk. For example, in the above figure, a portion of the Oracle Enterprise Manager is being installed.

Once the installation is completed, the next step will be to configure the various additional services and the database. This is shown below: 

 

Each of the configuration programs will be executed in turn. The HTTP Server (Oracle/Apache) should launch automatically and open up TCP/IP port 80. You should notice a new Command window as follows: 

Oracle HTTP Server Powered by Apache/1.3.12 (Win32) ApacheJServ/1.1 
mod_ssl/2.6.4 OpenSSL/0.9.5a mod_perl/1.24 running...

The Net Configuration Assistant and Oracle Intelligent Agent should run automatically and not present any sustained screens.

The Oracle Database Configuration Assistant will appear for some time while the default database is created and opened. As below: 

 

Once the default database has been installed, the following screen will appear:

 

Click the OK button when done.

This should conclude the configuration of the database and the "End of Installation" screen should appear as below. Click on the Exit button and click on the following Yes button to confirm exiting the Installation program.

 

At this point, be sure to reboot your computer so any final changes can take affect. In particular, the path d:\oracle\ora92\bin will be added to the PATH environment variable.


New Program Groups

After Oracle9i is installed, you will notice several new program groups in the Start menu.

 

These include:

  • Oracle Installation Products
    Tools to help manage the installation and removal of Oracle products on the machine.
  • Oracle - OraHome92
    the set of tools used to work with Oracle90. These include:
    • Application Development - Tools to develop Oracle applications including SQL*Plus
    • Configuration and Migration Tools - Tools to migrate older Oracle databases to version 9i
    • Enterprise Management Packs
    • Enterprise Manager Quick Tours
    • Integrated Management Tools
    • Oracle HTTP Server

Starting and Stopping the Database

Under Windows NT and Windows XP, the Oracle 9i database runs automatically as a service. Below is a view of the Windows XP Services management console showing the services installed by default…

 

Testing the Installation

Once the database is running, the SQL*Plus tool can be used to connect to the database.

Go to the Start -> Programs -> Oracle - OraHome92 -> Application Development program group and run the SQL Plus application. Once SQL Plus is running, you will be prompted for 3 things: Username, password and Host String.

The default Database Administrator's account has a username of SYSTEM and a default password of MANAGER. You may have changed the SYSTEM account password in a previous step so use the new password.

Fill in the Username and password fields with the SYSTEM account and leave the Host String field blank. Since we are connecting to a local Oracle database, no Host String is required. Click on the OK button as shown below:

If the database is running and the username and password are typed correctly, SQL*Plus should log the SYSTEM user in and present the SQL> prompt as shown below:

By default, you can also log in with the SCOTT/TIGER account. That is, there is a demo account already set up in the database with username SCOTT and password TIGER. Many of the examples in the Oracle documentation use the tables included in the SCOTT user's account.


Tips

·         To run iSQL*Plus

Run the internet explorer

In address bar type the ‘name of your computer’ or ‘localhost’ or ‘127.0.0.1’

Followed by ‘/isqlplus’...

It will appear like

http://amd/isqlplus or

http://localhost/isqlplus or

http://127.0.0.1/isqlplus.

 

·         To change the language from Arabic to English ENA

Run--> regedit
regedit--> HKEY_LOCAL_MACHINE
HKEY_LOCAL_MACHINE--> Software
Software--> Oracle

Search for NLS_LANG and change it to this value
NLS_LANG--> AMERICAN_JORDAN.AR8MSWIN1256

Note:
If you will found the value of NLS_LANG keys is N/A
Leave it and don't change it...


All Arabic...
ARABIC_JORDAN.AR8MSWIN1256

All English...
AMERICAN_AMERICA.WE8ISO8859P1

Back to top

©  A7MaD^2oOo4. All rights reserved.